






use "data\data1_regional.dta", clear



******************* Table A12
******************* 


***mftg
eststo clear
eststo R1: ivregress 2sls d_sh_empl_mfg  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R2: ivregress 2sls d_sh_empl_mfg_edu_nc  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R3: ivregress 2sls d_sh_empl_mfg_edu_c  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R4: ivregress 2sls d_sh_empl_mfg_f  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R5: ivregress 2sls d_sh_empl_mfg_m  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R6: ivregress 2sls d_sh_empl_mfg_age1634  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R7: ivregress 2sls d_sh_empl_mfg_age3549  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R8: ivregress 2sls d_sh_empl_mfg_age5064  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

esttab R1 R2 R3 R4 R5 R6 R7 R8 using "results\w4\tA12A.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "")  



***nmftg
eststo clear
eststo R1: ivregress 2sls d_sh_empl_nmfg  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R2: ivregress 2sls d_sh_empl_nmfg_edu_nc  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R3: ivregress 2sls d_sh_empl_nmfg_edu_c  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R4: ivregress 2sls d_sh_empl_nmfg_f  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R5: ivregress 2sls d_sh_empl_nmfg_m  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R6: ivregress 2sls d_sh_empl_nmfg_age1634  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R7: ivregress 2sls d_sh_empl_nmfg_age3549  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R8: ivregress 2sls d_sh_empl_nmfg_age5064  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

esttab R1 R2 R3 R4 R5 R6 R7 R8 using "results\w4\tA12B.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "")  


***empl
eststo clear
eststo R1: ivregress 2sls d_sh_empl  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R2: ivregress 2sls d_sh_empl_edu_nc  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R3: ivregress 2sls d_sh_empl_edu_c  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R4: ivregress 2sls d_sh_empl_f  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R5: ivregress 2sls d_sh_empl_m (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R6: ivregress 2sls d_sh_empl_age1634  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R7: ivregress 2sls d_sh_empl_age3549 (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R8: ivregress 2sls d_sh_empl_age5064 (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

esttab R1 R2 R3 R4 R5 R6 R7 R8 using "results\w4\tA12C.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "")  


***unempl
eststo clear
eststo R1: ivregress 2sls d_sh_unempl  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R2: ivregress 2sls d_sh_unempl_edu_nc  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R3: ivregress 2sls d_sh_unempl_edu_c  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R4: ivregress 2sls d_sh_unempl_f  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R5: ivregress 2sls d_sh_unempl_m  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R6: ivregress 2sls d_sh_unempl_age1634  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R7: ivregress 2sls d_sh_unempl_age3549  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R8: ivregress 2sls d_sh_unempl_age5064  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

esttab R1 R2 R3 R4 R5 R6 R7 R8 using "results\w4\tA12D.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "")  


***nilf
eststo clear
eststo R1: ivregress 2sls d_sh_nilf  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R2: ivregress 2sls d_sh_nilf_edu_nc  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R3: ivregress 2sls d_sh_nilf_edu_c  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R4: ivregress 2sls d_sh_nilf_f  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R5: ivregress 2sls d_sh_nilf_m  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R6: ivregress 2sls d_sh_nilf_age1634  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R7: ivregress 2sls d_sh_nilf_age3549  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)
eststo R8: ivregress 2sls d_sh_nilf_age5064  (d_tradeusch_pw=d_tradeotch_pw_lag) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_sh_routine33 l_task_outsource i.div [aw=time] , cluster(statefip)

esttab R1 R2 R3 R4 R5 R6 R7 R8 using "results\w4\tA12E.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "")  



******************* Table A17
******************* 

eststo clear

eststo R1: ivregress 2sls d_sh_empl_abstract (d_tradeusch_pw l_sh_routine33=d_tradeotch_pw_lag R33a_1950_90) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_task_outsource i.div [aw=time], cluster(statefip)

eststo R2: ivregress 2sls d_sh_empl_clerical (d_tradeusch_pw l_sh_routine33=d_tradeotch_pw_lag R33a_1950_90) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_task_outsource i.div [aw=time], cluster(statefip)

eststo R3: ivregress 2sls d_sh_empl_production (d_tradeusch_pw l_sh_routine33=d_tradeotch_pw_lag R33a_1950_90) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_task_outsource i.div [aw=time], cluster(statefip)

eststo R4: ivregress 2sls d_sh_empl_manual (d_tradeusch_pw l_sh_routine33=d_tradeotch_pw_lag R33a_1950_90) l_shind_manuf_cbp l_sh_popedu_c l_sh_popfborn l_sh_empl_f l_task_outsource i.div [aw=time], cluster(statefip)

esttab R1 R2 R3 R4 using "results\w4\tA17.tex", replace se obs star(* 0.10 ** 0.05 *** 0.01) label nocons nogaps b(%9.3f) se(%9.3f)  ///
mtitle("" "" "" "" "" "")  














